import xlrd


filePath = input("文件路径是：")
workBook = xlrd.open_workbook(filePath)
sheetNames = workBook.sheet_names()
print("当前文件中含有一下sheet: %s" % sheetNames)
findSheetFlag = input("请输入你要查找sheet的位置(从0开始，如果是所有，请直接输入all。)：")
findCol = input("请输入你寻找的列的位置(从0开始)：")
findContext = input("请输入要查找的内容:")
if findSheetFlag == 'all':
    print('all')
else:
    for sheetName in sheetNames:
        sheet = workBook.sheet_by_name(sheetName)
        cols = sheet.col_values(0)
        print(cols)
        # for colIndex in cols.index():
        #     if cols[colIndex] == findContext:
        #         print(colIndex)
